CustomerApi Odata Help Page

Customer - LoyaltyPoint

LoyaltyPoint entities

Required HTTP Headers

X-Crm360Api-Token
X-Crm360Api-CustomerName
X-Crm360Api-DatabaseAlias

Functions

Create
Read
Update
Delete

Entity Properties

Name	Type	Is Mandatory
LoyaltyPointId	Int32
PurchaseHeaderId	Int32
VoucherId	Int32
ContactId	Int32
LoyaltyCardId	Int32
PointTypeId	Int16
PointAmount	Decimal
PointOriginalAmount	Decimal
PointUsedAmount	Decimal
PointExpiredAmount	Decimal
DatePoint	DateTime
ExpiredDatePoint	DateTime
FreeField1	String
FreeField2	String
FreeField3	String
FreeField4	String
FreeField5	String
FreeFieldDateTime1	DateTime
FreeFieldDateTime2	DateTime
FreeFieldDateTime3	DateTime
FreeFieldDateTime4	DateTime
FreeFieldDateTime5	DateTime
FreeFieldNumber1	Decimal
FreeFieldNumber2	Decimal
FreeFieldNumber3	Decimal
FreeFieldNumber4	Decimal
FreeFieldNumber5	Decimal
FreeFieldBoolean1	Boolean
FreeFieldBoolean2	Boolean
FreeFieldBoolean3	Boolean
FreeFieldBoolean4	Boolean
FreeFieldBoolean5	Boolean
DeletionFlag	Boolean
PointIdentifier	String
SourceId	Int16
PurchaseHeader	PurchaseHeader
Contact	Contact
LoyaltyCard	LoyaltyCard
LoyaltyPointType	LoyaltyPointType
Source	Source
Voucher	Voucher

Examples

Select all LoyaltyPoints
https://customerapi.fts-crm360.com/data/LoyaltyPoints()
HttpMethod : GET                                                                                       
Json Result : 

[
{
"LoyaltyPointId" : "87",
"PurchaseHeaderId" : "91",
"VoucherId" : "6",
"ContactId" : "92",
"LoyaltyCardId" : "30",
"PointTypeId" : "6",
"PointAmount" : "8781288.291",
"PointOriginalAmount" : "1599272.669",
"PointUsedAmount" : "6596713.435",
"PointExpiredAmount" : "3247431.814",
"DatePoint" : "2006-03-18T00:00:00",
"ExpiredDatePoint" : "1999-05-12T00:00:00",
"FreeField1" : "8uAAntJsb",
"FreeField2" : "VAVwRYEi",
"FreeField3" : "9ez4DRi4nWjR",
"FreeField4" : "eQ71qDloDx02F",
"FreeField5" : "dzd7 3KwJ07uEz",
"FreeFieldDateTime1" : "2010-09-06T00:00:00",
"FreeFieldDateTime2" : "2005-05-10T00:00:00",
"FreeFieldDateTime3" : "2020-07-04T00:00:00",
"FreeFieldDateTime4" : "2023-07-28T00:00:00",
"FreeFieldDateTime5" : "2017-06-21T00:00:00",
"FreeFieldNumber1" : "5184719.897",
"FreeFieldNumber2" : "9196548.865",
"FreeFieldNumber3" : "7358173.585",
"FreeFieldNumber4" : "4993296.479",
"FreeFieldNumber5" : "8131289.254",
"FreeFieldBoolean1" : "True",
"FreeFieldBoolean2" : "False",
"FreeFieldBoolean3" : "False",
"FreeFieldBoolean4" : "False",
"FreeFieldBoolean5" : "False",
"DeletionFlag" : "False",
"PointIdentifier" : "BZ9rb XS Hobm",
"SourceId" : "7"
},
{
"LoyaltyPointId" : "45",
"PurchaseHeaderId" : "11",
"VoucherId" : "68",
"ContactId" : "57",
"LoyaltyCardId" : "66",
"PointTypeId" : "1",
"PointAmount" : "5627295.897",
"PointOriginalAmount" : "4394698.341",
"PointUsedAmount" : "9727379.634",
"PointExpiredAmount" : "6942242.355",
"DatePoint" : "2011-05-13T00:00:00",
"ExpiredDatePoint" : "2010-09-10T00:00:00",
"FreeField1" : "RvZeRJdTaH",
"FreeField2" : "Kr g dB0jjJa0y",
"FreeField3" : "Lxiv8cW",
"FreeField4" : "566MobyCIzw",
"FreeField5" : "b q Aas8wHUisE8rwqK",
"FreeFieldDateTime1" : "2000-08-14T00:00:00",
"FreeFieldDateTime2" : "2018-10-09T00:00:00",
"FreeFieldDateTime3" : "2003-04-25T00:00:00",
"FreeFieldDateTime4" : "2009-10-06T00:00:00",
"FreeFieldDateTime5" : "2012-03-20T00:00:00",
"FreeFieldNumber1" : "5344851.618",
"FreeFieldNumber2" : "7217757.468",
"FreeFieldNumber3" : "6455513.566",
"FreeFieldNumber4" : "2251471.323",
"FreeFieldNumber5" : "1759486.196",
"FreeFieldBoolean1" : "True",
"FreeFieldBoolean2" : "False",
"FreeFieldBoolean3" : "True",
"FreeFieldBoolean4" : "False",
"FreeFieldBoolean5" : "False",
"DeletionFlag" : "False",
"PointIdentifier" : "15rOi8gojr Y eaM",
"SourceId" : "4"
},
...
]

Select LoyaltyPoint by Id
https://customerapi.fts-crm360.com/data/LoyaltyPoints(87)
HttpMethod : GET                                                                                       
Json Result : 

{
"LoyaltyPointId" : "68",
"PurchaseHeaderId" : "89",
"VoucherId" : "93",
"ContactId" : "61",
"LoyaltyCardId" : "20",
"PointTypeId" : "7",
"PointAmount" : "5359275.823",
"PointOriginalAmount" : "9245167.937",
"PointUsedAmount" : "1669212.311",
"PointExpiredAmount" : "2263291.949",
"DatePoint" : "1996-08-06T00:00:00",
"ExpiredDatePoint" : "2021-02-11T00:00:00",
"FreeField1" : "I UCtWGI Xal4kj0Gh",
"FreeField2" : "wAEzgJSB",
"FreeField3" : "whWtMsg7 8e54",
"FreeField4" : "KyNnSZcIRWzH2CLz3 T",
"FreeField5" : "YcAsYMCm JCU1",
"FreeFieldDateTime1" : "1997-06-07T00:00:00",
"FreeFieldDateTime2" : "2021-08-06T00:00:00",
"FreeFieldDateTime3" : "1995-10-30T00:00:00",
"FreeFieldDateTime4" : "2003-07-08T00:00:00",
"FreeFieldDateTime5" : "2010-08-06T00:00:00",
"FreeFieldNumber1" : "1616319.185",
"FreeFieldNumber2" : "7111636.775",
"FreeFieldNumber3" : "3148223.538",
"FreeFieldNumber4" : "2254475.721",
"FreeFieldNumber5" : "8346891.975",
"FreeFieldBoolean1" : "False",
"FreeFieldBoolean2" : "False",
"FreeFieldBoolean3" : "True",
"FreeFieldBoolean4" : "False",
"FreeFieldBoolean5" : "False",
"DeletionFlag" : "False",
"PointIdentifier" : "NdGsbzBUk",
"SourceId" : "5"
}

Create a LoyaltyPoint
https://customerapi.fts-crm360.com/data/LoyaltyPoints()
HttpMethod : POST                                                                                                
Json Post :
{
"PurchaseHeaderId" : "71",
"VoucherId" : "67",
"ContactId" : "93",
"LoyaltyCardId" : "80",
"PointTypeId" : "8",
"PointAmount" : "5779779.214",
"PointOriginalAmount" : "7739971.543",
"PointUsedAmount" : "3134533.354",
"PointExpiredAmount" : "3877751.425",
"DatePoint" : "2002-01-03T00:00:00",
"ExpiredDatePoint" : "2004-04-29T00:00:00",
"FreeField1" : "XsDxXq",
"FreeField2" : "oKhffZbXbYfrqpB7",
"FreeField3" : "iP rt",
"FreeField4" : "3C8A7pai4",
"FreeField5" : "tuGPNMTCq5y ho",
"FreeFieldDateTime1" : "2007-02-14T00:00:00",
"FreeFieldDateTime2" : "2004-07-04T00:00:00",
"FreeFieldDateTime3" : "2017-01-02T00:00:00",
"FreeFieldDateTime4" : "1996-08-04T00:00:00",
"FreeFieldDateTime5" : "2001-09-23T00:00:00",
"FreeFieldNumber1" : "2319865.545",
"FreeFieldNumber2" : "7186199.978",
"FreeFieldNumber3" : "4941858.536",
"FreeFieldNumber4" : "6943846.836",
"FreeFieldNumber5" : "7695999.457",
"FreeFieldBoolean1" : "False",
"FreeFieldBoolean2" : "True",
"FreeFieldBoolean3" : "True",
"FreeFieldBoolean4" : "False",
"FreeFieldBoolean5" : "False",
"DeletionFlag" : "True",
"PointIdentifier" : "CHVx7Nx3zog sRIqFB",
"SourceId" : "7"
}
            
Informations : 
 - Non mandatory fields are optional for Json Post

Update a LoyaltyPoint
https://customerapi.fts-crm360.com/data/LoyaltyPoints(87)
HttpMethod : PUT                                                                                                
Json Post :
{
"LoyaltyPointId" : "2",
"PurchaseHeaderId" : "83",
"VoucherId" : "5",
"ContactId" : "89",
"LoyaltyCardId" : "56",
"PointTypeId" : "5",
"PointAmount" : "1622824.656",
"PointOriginalAmount" : "6988426.234",
"PointUsedAmount" : "6744792.221",
"PointExpiredAmount" : "1383966.795",
"DatePoint" : "1997-05-10T00:00:00",
"ExpiredDatePoint" : "2001-07-06T00:00:00",
"FreeField1" : "qdwQNP2K",
"FreeField2" : "nH5RNye24Obal Gg50",
"FreeField3" : "9KuWVgu18r 8",
"FreeField4" : "2GlpXmX1K",
"FreeField5" : "m1xzED",
"FreeFieldDateTime1" : "2013-11-17T00:00:00",
"FreeFieldDateTime2" : "2016-11-10T00:00:00",
"FreeFieldDateTime3" : "2003-09-12T00:00:00",
"FreeFieldDateTime4" : "2006-10-28T00:00:00",
"FreeFieldDateTime5" : "2005-07-19T00:00:00",
"FreeFieldNumber1" : "2797675.952",
"FreeFieldNumber2" : "9325585.235",
"FreeFieldNumber3" : "6812567.683",
"FreeFieldNumber4" : "9769747.988",
"FreeFieldNumber5" : "8969766.363",
"FreeFieldBoolean1" : "False",
"FreeFieldBoolean2" : "False",
"FreeFieldBoolean3" : "False",
"FreeFieldBoolean4" : "True",
"FreeFieldBoolean5" : "False",
"DeletionFlag" : "False",
"PointIdentifier" : "xP B0JMOMtN1GG",
"SourceId" : "6"
}
            
Informations : 
 - Non mandatory fields are optional for Json Post

Patch a LoyaltyPoint
https://customerapi.fts-crm360.com/data/LoyaltyPoints(87)
HttpMethod : PATCH                                                                                                
Json Post :
{
"DeletionFlag" : "True",
"VoucherId" : "45",
"FreeFieldBoolean5" : "True",
"ExpiredDatePoint" : "2016-05-20T00:00:00",
"FreeFieldNumber1" : "2249951.524",
"FreeFieldBoolean3" : "True",
"FreeFieldNumber2" : "6337968.817",
"FreeFieldBoolean2" : "False",
"LoyaltyCardId" : "68",
"PointOriginalAmount" : "5844526.354",
"FreeFieldNumber4" : "9354316.761",
"FreeFieldBoolean1" : "False",
"PointUsedAmount" : "5196429.565",
"SourceId" : "9",
"ContactId" : "69"
}
            
Informations : 
 - Non mandatory fields are optional for Json Post

Delete a LoyaltyPoint
https://customerapi.fts-crm360.com/data/LoyaltyPoints(87)
HttpMethod : DELETE